package com.water.Service;

import java.sql.SQLException;
import java.util.List;

import com.water.domain.ArticleListBean;
import com.water.domain.ColumnListBean;
import com.water.domain.PageBean;
import com.water.domain.UserListBean;


public interface WaterService {
    /**
     * 查询所有用户列表
     *
     * @author Hallock
     *//*
    List<UserListBean> findAll() throws SQLException;

    *//**
     * 查询所有文章列表
     *
     * @return
     * @throws SQLException
     *//*
    List<ArticleListBean> FindArticleAll() throws SQLException;

    *//**
     * 查询所有栏目管理
     *
     * @return
     * @throws SQLException
     *//*
    List<ColumnListBean> FindColumnAll() throws SQLException;
*/

    /**
     * 删除栏目
     *
     * @param id
     * @throws SQLException
     */
    void DeleteColumn(int id) throws SQLException;

    /**
     * 删除文章
     *
     * @param id
     * @throws SQLException
     */
    void DeleteArticle(int id) throws SQLException;

    /**
     * 添加栏目
     *
     * @param columnListBean
     * @throws SQLException
     */
    void InsertColumn(ColumnListBean columnListBean) throws SQLException;


    /**
     * 模糊查询
     *
     * @param title
     * @param status
     * @return
     * @throws SQLException
     */
    List<ArticleListBean> search(String title, String status) throws SQLException;

    /**
     * 用户分页查询
     *
     * @param currentPage
     * @return
     * @throws SQLException
     */
    PageBean findUserByPage(int currentPage) throws SQLException;

    /**
     * 文章分页查询
     *
     * @param currentPage
     * @return
     * @throws SQLException
     */
    PageBean findArticleByPage(int currentPage) throws SQLException;

    /**
     * 栏目分页查询
     *
     * @param currentPage
     * @return
     * @throws SQLException
     */
    PageBean findColumnByPage(int currentPage) throws SQLException;
}
